<!-- If the browser does not support frames put the first topic content here --> <div class="Section1"> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt; background:#DFDFDF'> <p class="MsoHeader" align="center" style= 'text-align:center;background:#DFDFDF; border:none;padding:0cm'> <b><span style='font-size:14.0pt'>REVISIONS</span></b></p> <p class="MsoHeader" align="center" style= 'text-align:center;background:#DFDFDF; border:none;padding:0cm'> <b><span style='font-size:14.0pt'>Manipulation des données et langage de définition de données</span></b></p> </div> <p class="MsoHeader"> </p> <p class="MsoNormal"><b><i><u>Travaux préliminaires :</u></i></b></p> <p class="MsoNormal">Le travail est à réaliser sous Oracle ou MySql.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">- Démarrer Oracle. Auparavant démarrer le service si nécessaire.</p> <p class="MsoNormal">- Se connecter avec le nom d’utilisateur scott et le mot de passe tiger</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Ou</p> <p class="MsoNormal">- Démarrer PhpMyAdmin (version MySql)</p> <p class="MsoNormal"> </p> <p class="MsoHeader"><b><i><u>Remarque importante :</u></i></b></p> <p class="MsoHeader"><b><i>Le texte de chaque requête doit être placé dans un fichier (ex : fichier R1.sql pour la</i></b></p> <p class="MsoHeader"><b><i>requête 1). Utiliser un répertoire pour chacune des deux parties de ce travail.</i></b></p> <p class="MsoHeader"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <h1 style='border:none;padding:0cm'><a name="node0" id= "node0"></a><span style='text-decoration:none'>1ERE PARTIE : CAS EMPLOYES</span></h1> </div> <p class="MsoHeader" style='margin-top:9.0pt'><b><u><span style= 'font-size:14.0pt'><span style= 'text-decoration:none'> </span></span></u></b></p> <h2><a name="node1" id="node1"></a><u>Ecrire et exécuter les requêtes ci-dessous : </u></h2> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 1)<span style= 'font:7.0pt "Times New Roman"'> </span> Obtenir les départements (numéro, nom) ayant des employés.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 2)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner la liste des employés (numéro, nom) non vendeurs.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 3)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner les employés embauchés entre le 01-01-1981 et le 30-06-81.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 4)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner le salaire le plus élevé et le salaire le plus bas par département et job.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 5)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner pour chaque département : son nom, le nombre d’employés et la moyenne des salaires.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 6)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner le montant total des commissions des vendeurs.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 7)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner pour chaque employé : son nom, sa fonction et le nom de son département. Le résultat devra être ordonné sur le nom de l'employé.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 8)<span style= 'font:7.0pt "Times New Roman"'> </span> Donner le nom et le job de la dernière personne embauchée dans le département ‘ACCOUNTING’.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 9)<span style= 'font:7.0pt "Times New Roman"'> </span> Lister les employés (no, nom) dont le salaire est supérieur à la moyenne des salaires.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 10)<span style='font:7.0pt "Times New Roman"'> </span> Donner le nombre d’employés n’ayant pas de responsable.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 11)<span style='font:7.0pt "Times New Roman"'> </span> Donner la liste des employés (numéro, nom et job) avec le nom de leur responsable.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 12)<span style='font:7.0pt "Times New Roman"'> </span> On peut constater que le chef ne figure pas dans la liste de la question précédente (c'est logique car il n'a pas de responsable), il est demandé de l'ajouter dans cette liste (penser à UNION).</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 13)<span style='font:7.0pt "Times New Roman"'> </span> Donner la liste des employés dont le nom commence par A.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 14)<span style='font:7.0pt "Times New Roman"'> </span> Donner la liste des employés (numéro, nom) avec leur salaire total ordonnée sur le nom de l'employé ; attention si on ajoute NULL à un nombre, le résultat vaut NULL.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 15)<span style='font:7.0pt "Times New Roman"'> </span> Augmenter les salaires des vendeurs de 1%.</p> <p class="MsoNormal" style= 'margin-top:3.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:35.7pt;margin-bottom:.0001pt;text-indent:-17.85pt'> 16)<span style='font:7.0pt "Times New Roman"'> </span> Insérer un département (la seule contrainte est que le numéro doit être égal au dernier + 10).</p> <span style= 'font-size:12.0pt;font-family:"Times New Roman"'><br clear="all" style='page-break-before:always' /></span> <p class="MsoNormal" style='margin-left:18.0pt'> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <h1 style='border:none;padding:0cm'><a name="node2" id= "node2"></a><span style='text-decoration:none'>2EME PARTIE : CAS CAFE</span></h1> </div> <p class="MsoHeader"> </p> <p class="MsoNormal">Le café "Au père tranquille" veut disposer d’une base de données relationnelle sous Oracle.</p> <p class="MsoNormal">Le modèle "physique" des données (MPD) sous AMC Designor se présente ainsi :</p> <p class="MsoNormal"></p> <table cellpadding="0" cellspacing="0" align="left"> <tr> <td width="19" height="5"></td> </tr> <tr> <td></td> <td><img width="535" height="301" src= "En_BD_SLAM_Atelier1.doc%20(R%C3%A9visions)_fichiers/image001.gif" alt="image" /></td> </tr> </table> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"><b> </b></p> <p class="MsoNormal"><b> </b></p> <p class="MsoNormal"><b> </b></p> <br clear="all" /> <p class="MsoNormal"><b>Le contenu des différentes tables figure en annexe 2.</b></p> <p class="MsoNormal"><b> </b></p> <p class="MsoNormal" style='background:#D9D9D9'><b><span style= 'font-size:14.0pt'>TRAVAIL A REALISER</span></b></p> <p class="MsoHeader" style='margin-top:9.0pt'><b><u><span style= 'font-size:14.0pt'><span style= 'text-decoration:none'> </span></span></u></b></p> <h2><a name="node3" id="node3"></a><u>Création des tables :</u></h2> <p class="MsoHeader">Ecrire les requêtes de création des tables.</p> <p class="MsoHeader">Attention à l'ordre pour l'exécution.</p> <p class="MsoHeader">Penser aux contraintes de clés primaires et étrangères et à la contrainte NOT NULL (seules l'adresse et la date de naissance du serveur peuvent être à NULL). Le prix de la consommation doit être compris entre 1 et 10 euros. Si les factures sont supprimées, on souhaite que les lignes de facture soient également supprimées.</p> <p class="MsoHeader">Respecter impérativement les noms des attributs.</p> <p class="MsoHeader">Le code postal est de type CHAR(5).</p> <p class="MsoHeader">Les chaînes sont à déclarer avec le type VARCHAR(longueur maximale).</p> <h2><a name="node4" id="node4"></a><u>Alimentation des tables :</u></h2> <p class="MsoHeader">Pour remplir les tables : il faut copier le fichier insercafe.sql (situé echange/phl/IG2/ALSI-BD/BD/Atelier1 (Révisions)) en local, l’ouvrir et l'exécuter.</p> <b><i><u><span style= 'font-size:12.0pt;font-family:Arial'><br clear="all" style= 'page-break-before:always' /></span></u></i></b> <h2><a name="node5" id="node5"></a><u>Ecrire et exécuter les requêtes ci-dessous : </u></h2> <p class="MsoNormal"><i> </i></p> <p class="MsoNormal">1) Ajouter un attribut commentaire, d'une longueur de 80, dans la table des serveurs.</p> <p class="MsoHeader"> </p> <p class="MsoNormal">2) Ajouter la contrainte "quantité facturée obligatoirement positive" dans la table des lignes de facture.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">3) Dans la table des serveurs, faire passer la longueur de la ville à 35 caractères.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">4) Interdire la création de doublons sur les noms des serveurs.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">5) Obtenir la liste des factures avec pour chaque facture le numéro de la facture, le nom de la table et la date de la facture.</p> <p class="MsoHeader"><span lang="EN-GB" xml:lang= "EN-GB"> </span></p> <p class="MsoHeader">6) Obtenir les noms des consommations servies le 22/02/1997.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">7) Connaître le nombre de serveurs.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">8) Ajouter le serveur n°54, il s'appelle Lulu, habite 35, rue des Lilas 69000 Lyon et est né le 20/06/76.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">9) Obtenir les numéros et nombre de places des tables qui n'ont pas été occupées.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">10) Connaître le nom et le prix de la consommation la moins chère.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">11) Obtenir le numéro, la date et le montant total de chaque facture.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">12) Augmenter de 10% le prix du café, café double et café crème.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">13) Connaître les noms des serveurs ayant effectué plus de 25 euros de chiffre d'affaires.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">14) Dans la facture 1207, la consommation 108 a été saisie par erreur, faire le nécessaire.</p> <p class="MsoHeader"> </p> <p class="MsoHeader">15) Connaître le nom et l'âge de chaque serveur. Pour extraire l'année, il faudra utiliser la fonction YEAR<b><span style='font-size: 10.0pt'>.</span></b></p> <p class="MsoHeader"><b><u><span style= 'font-size:14.0pt'><span style= 'text-decoration: none'> </span></span></u></b></p> <p class="MsoHeader"><b><u><span style= 'font-size:14.0pt'><span style= 'text-decoration: none'> </span></span></u></b></p> <b><u><span style= 'font-size:14.0pt;font-family:"Times New Roman"'><br clear="all" style='page-break-before:always' /></span></u></b> <p class="MsoHeader"><b><u><span style= 'font-size:14.0pt'><span style= 'text-decoration: none'> </span></span></u></b></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <h1 style='border:none;padding:0cm'><a name="node6" id= "node6"></a><span style= 'font-weight:normal;text-decoration: none'>ANNEXE 1</span></h1> </div> <p class="MsoHeader"> </p> <p class="MsoHeader"><b><u>Table dept (table des départements)</u></b></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">deptno numeric(2) clé primaire</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">dname varchar(30)</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">loc varchar(20)</span></p> <p class="MsoHeader">Tous les champs sont obligatoires.</p> <p class="MsoHeader"><span lang="EN-GB" xml:lang="EN-GB">Exemple :</span></p> <p class="MsoHeader"><span lang="EN-GB" xml:lang= "EN-GB">10 ACCOUNTING NEW YORK</span></p> <p class="MsoHeader"><span lang="EN-GB" xml:lang= "EN-GB"> </span></p> <p class="MsoHeader"><b><u>Table emp (table des employés)</u></b></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">empno numeric(4) clé primaire</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">ename varchar(30)</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">job varchar(30)</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">mgr numeric(4)</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">hiredate date</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">sal numeric (8,2)</span></p> <p class="MsoHeader"><span lang="EN-GB" style='font-size:10.0pt' xml:lang="EN-GB">comm numeric(8,2)</span></p> <p class="MsoHeader"><span style='font-size:10.0pt'>deptno numeric(2) clé étrangère</span></p> <p class="MsoHeader"> </p> <p class="MsoHeader">mgr désigne le numéro du responsable.</p> <p class="MsoHeader">sal est le salaire.</p> <p class="MsoHeader">comm est la commission (uniquement renseignée pour les vendeurs).</p> <p class="MsoHeader">Le lien entre les 2 tables se fait par deptno.</p> <p class="MsoHeader">Tous les champs sont obligatoires sauf le numéro de responsable (mgr) et la commission (comm).</p> <p class="MsoHeader"><span lang="EN-GB" xml:lang="EN-GB">Exemple :</span></p> <p class="MsoHeader"><span lang="EN-GB" xml:lang= "EN-GB">7369 SMITH CLERK 7902 17/12/80 800 20</span></p> <p class="MsoHeader"> </p> <u><span style='font-size:16.0pt;font-family:Arial'><br clear="all" style='page-break-before:always' /></span></u> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <h1 style='border:none;padding:0cm'><a name="node7" id= "node7"></a><span style= 'font-size:16.0pt;font-weight: normal;text-decoration:none'>ANNEXE 2</span></h1> </div> <p class="MsoNormal"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt; background:#BFBFBF'> <p class="MsoNormal" style= 'background:#BFBFBF;border:none;padding:0cm'>VOICI LE CONTENU (FICTIF) DES DIFFERENTES TABLES :</p> </div> <p class="MsoNormal"><i> </i></p> <p class="MsoNormal"><i>Table des consommations : CONSO Clé : NumCons</i></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style='margin-left:2.0pt;border-collapse:collapse'> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumCons</span></b></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>LibCons</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>PrixCons</span></b></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>100</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Café</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1.20 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>101</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Café double</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>102</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Café crème</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">1.50 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">105</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">Chocolat</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">2.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>106</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Bière pression</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2.50 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>107</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Bière 25cl</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>108</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Bière 33cl</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>110</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Bière 50cl</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>5.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>120</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Jus de fruits</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2.50 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>121</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Jus de fruit pressé</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">3.00 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">122</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">Perrier</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">2.50 e</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">124</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">Orangina</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">2.40 €</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">130</span></p> </td> <td width="173" valign="top" style= 'width:130.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">Coca Cola</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2.40 €</span></p> </td> </tr> </table> <p class="MsoHeader"> </p> <p class="MsoHeader"><i> </i></p> <p class="MsoHeader"><i> </i></p> <p class="MsoHeader"><i>Table des factures : FACTURE Clé : NumFact</i></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style='margin-left:2.0pt;border-collapse:collapse'> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumFact</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumTable</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumServ</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>DateFact</span></b></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1200</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>53</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>21/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1201</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>5</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>53</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>21/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1202</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>52</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>21/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1203</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>5</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>50</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>21/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1204</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>52</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>22/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1205</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>53</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>22/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1206</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>52</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>22/02/2006</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1207</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>5</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>53</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>22/02/2006</span></p> </td> </tr> </table> <p class="MsoHeader"> </p> <p class="MsoHeader"><i>Table des tables du café : TABLES Clé : NumTable</i></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style='margin-left:2.0pt;border-collapse:collapse'> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumTable</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NomTable</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NbPlaces</span></b></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>entree-gche</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>6</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>entree-dte</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>10</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>fenetre1</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>fenetre2</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>8</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>5</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>fenetre3</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>6</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>fond-gche</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>7</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>fond-drt</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> </table> <p class="MsoHeader"> </p> <p class="MsoHeader"><i>Table des lignes factures : LIGNE_FACT Clé : NumFact + NumCons</i></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style='margin-left:2.0pt;border-collapse:collapse'> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumFact</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumCons</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>Qte</span></b></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1200</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>101</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1200</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>106</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1200</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>120</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1201</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>105</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1201</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>106</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1202</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>100</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1202</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>122</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1203</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>102</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1203</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>108</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1203</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>121</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1203</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>130</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1204</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>122</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>4</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1204</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>124</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1205</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>100</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1206</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>108</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>3</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1207</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>108</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="96" valign="top" style= 'width:71.85pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>1207</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>110</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>2</span></p> </td> </tr> </table> <p class="MsoHeader"> </p> <p class="MsoHeader"><i>Table des serveurs : SERVEUR Clé : NumServ</i></p> <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style='margin-left:2.0pt;border-collapse:collapse'> <tr style='height:13.5pt'> <td width="76" valign="top" style= 'width:57.25pt;border:solid black 1.0pt; background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NumServ</span></b></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>NomServ</span></b></p> </td> <td width="159" valign="top" style= 'width:119.0pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>RueServ</span></b></p> </td> <td width="66" valign="top" style= 'width:49.6pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>CpServ</span></b></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>VilleServ</span></b></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border:solid black 1.0pt; border-left:none;background:silver;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style= 'font-family:Arial;color:black;layout-grid-mode:line'>DateNaisss</span></b></p> </td> </tr> <tr style='height:13.5pt'> <td width="76" valign="top" style= 'width:57.25pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>50</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Pizzi</span></p> </td> <td width="159" valign="top" style= 'width:119.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>3, rue des lilas</span></p> </td> <td width="66" valign="top" style= 'width:49.6pt;border-top:none;border-left:none; border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt;background: white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">90000</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">BELFORT</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">10/12/1986</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="76" valign="top" style= 'width:57.25pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span lang="EN-GB" style= 'font-family:Arial;color:black;layout-grid-mode:line' xml:lang= "EN-GB">51</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">Cathy</span></p> </td> <td width="159" valign="top" style= 'width:119.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span lang="EN-GB" style= 'font-family:Arial;color:black; layout-grid-mode:line' xml:lang= "EN-GB">25, av Roosevelt</span></p> </td> <td width="66" valign="top" style= 'width:49.6pt;border-top:none;border-left:none; border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt;background: white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>90100</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>DELLE</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>05/06/1985</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="76" valign="top" style= 'width:57.25pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>52</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Totof</span></p> </td> <td width="159" valign="top" style= 'width:119.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>46, grande rue</span></p> </td> <td width="66" valign="top" style= 'width:49.6pt;border-top:none;border-left:none; border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt;background: white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>90500</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>BAVILLIERS</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>03/09/1986</span></p> </td> </tr> <tr style='height:13.5pt'> <td width="76" valign="top" style= 'width:57.25pt;border:solid silver 1.0pt; border-top:none;background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>53</span></p> </td> <td width="96" valign="top" style= 'width:71.85pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>Pilou</span></p> </td> <td width="159" valign="top" style= 'width:119.0pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="left" style='text-align:left'> <span style= 'font-family: Arial;color:black;layout-grid-mode:line'>5, impasse Martin</span></p> </td> <td width="66" valign="top" style= 'width:49.6pt;border-top:none;border-left:none; border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt;background: white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>90000</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal"><span style= 'font-family:Arial;color:black;layout-grid-mode: line'>BELFORT</span></p> </td> <td width="104" valign="top" style= 'width:77.95pt;border-top:none;border-left: none;border-bottom:solid silver 1.0pt;border-right:solid silver 1.0pt; background:white;padding:0cm 2.0pt 0cm 2.0pt;height:13.5pt'> <p class="MsoNormal" align="right" style='text-align:right'> <span style= 'font-family:Arial;color:black;layout-grid-mode:line'>09/08/1986</span></p> </td> </tr> </table> <p class="MsoHeader"> </p> </div>
Table des matières
Sujets
Recherche
1ERE PARTIE : CAS EMPLOYES
Ecrire et exécuter les requêtes ci-dessous :
2EME PARTIE : CAS CAFE
Création des tables :
Alimentation des tables :
Ecrire et exécuter les requêtes ci-dessous :
ANNEXE 1
ANNEXE 2
1ERE PARTIE : CAS EMPLOYES
2EME PARTIE : CAS CAFE
Alimentation des tables :
ANNEXE 1
ANNEXE 2
Création des tables :
Ecrire et exécuter les requêtes ci-dessous :
Ecrire et exécuter les requêtes ci-dessous :
Générée avec
chmProcessor
Générée avec
chmProcessor